************************************************
***Title: summary_statistics.do
***Creators: Joelle Abramowitz, Shooshan Danagoulian, and Owen Fleming*
***Notes: This file produces the summary statistics table.

*For questions, contact
*Owen Fleming
*hg3490@wayne.edu
************************************************


**********SETUP
use data/for_analysis, clear


**********PRODUCE ESTIMATES
gen observations=1

collapse (mean) pollen_mean = pollen (sd) pollen_sd = pollen (mean) count_mean = count (sd) count_sd = count (mean) tmean_mean = tmean (sd) tmean_sd = tmean (mean) ppt_mean = ppt (sd) ppt_sd = ppt (mean) wind_speed_mean = wind_speed (sd) wind_speed_sd = wind_speed (sum) observations, by(pollen_quartile_ls)
xpose, clear varname
order _varname


**********EXPORT
export excel using results/summary_statistics.xls, replace
